package com.ssm.mapper;

import com.ssm.hj.search.MemberSearch;
import com.ssm.hj.view.MemberStatisticsView;
import com.ssm.hj.view.MemberView;
import com.ssm.pojo.Member;
import org.apache.ibatis.annotations.Param;
import com.ssm.hxj.view.tjscView;
import com.ssm.hxj.search.tjscSearch;

import java.util.List;

public interface MemberMapper {
    //阿杰 条件查询会员信息
    List<MemberView> searchQueryMember(MemberSearch memberSearch) throws Exception;
    //阿杰 修改状态
    int updateState(@Param("id") String id,@Param("state") int state) throws Exception;
    //阿杰 新增会员
    int save(Member member) throws Exception;
    //查询会员信息
    List<tjscView>searchQuerytjMember(tjscSearch tjscSearch) throws Exception;

    List<Member> queryMemberByName(String name);

    String queryMemberIdLast();

    void insertMemberId(String memberId);

    List<MemberStatisticsView> queryMemberLoginRecord(@Param("sdate") String sdate, @Param("endate") String enddate);

    List<MemberStatisticsView> queryBookingSum(@Param("sdate") String sdate,@Param("endate") String enddate);
}
